CREATE TABLE [dbo].[T_GENDER]
(
[GENDER_ID] [int] NOT NULL IDENTITY(1, 1),
[GENDER_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GENDER_CODE] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GENDER_STATUS] [bit] NOT NULL,
[CREATE_DATE] [datetime] NOT NULL,
[DISABLE_DATE] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_GENDER] ADD CONSTRAINT [PK__T_GENDER__E0F0815E1E830E1D] PRIMARY KEY CLUSTERED  ([GENDER_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_GENDER] ADD CONSTRAINT [UQ__T_GENDER__C71F3CC3CCEFE9A6] UNIQUE NONCLUSTERED  ([GENDER_CODE]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_GENDER] ADD CONSTRAINT [UQ__T_GENDER__FA9F0C68716D6977] UNIQUE NONCLUSTERED  ([GENDER_NAME]) ON [PRIMARY]
GO
